<?php
namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller
{
    public function index()
    {
        $this->show('<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} body{ background: #fff; font-family: "微软雅黑"; color: #333;font-size:24px} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.8em; font-size: 36px } a,a:hover{color:blue;}</style><div style="padding: 24px 48px;"> <h1>:)</h1><p>欢迎使用 <b>ThinkPHP</b>！</p><br/>版本 V{$Think.version}</div><script type="text/javascript" src="http://ad.topthink.com/Public/static/client.js"></script><thinkad id="ad_55e75dfae343f5a1"></thinkad><script type="text/javascript" src="http://tajs.qq.com/stats?sId=9347272" charset="UTF-8"></script>','utf-8');
    }

    public function add()
    {
        $data['name']="wwq_create";
        $data['age']=123;
        $user=M("User");
        //调用create来填充数据到对象
        // $user->create();
        // 调用add来保存到数据库
        //data方法,可以获取/存入数据
        $user->data($data)->add();
        # code...
        //create和data($data)都可以创造数据对象,可以进行数据操作
    }

    public function select()
    {
        $user=M("user");
        //find查找一个数据
        $data=$user->where('name="wwq"')->find();
        dump($data);
        //select查找一组数据
        $list=$user->where('name="wwq"')->select();
        dump($list);
        # code...
    }

    public function update()
    {
        
        $user=M("user");
        $data['name']="wwc";
        $user->where('id=3')->data($data)->save();
        # code...

        $user=M("user");
        $user->create();
        $user->name="wwc1";
        $user->where('id=4')->save();
    }


    public function delete()
    {
        $user=M("user");
        $user->where('age=12')->delete();
    }
}